USE [AMS]
GO

/****** Object:  StoredProcedure [dbo].[AddAnalysisMethod]    Script Date: 03/01/2010 18:58:01 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		Johan Celis
-- Create date: 30/12/2009
-- Description:	
-- Change date: 1/3/2010
-- Description: nieuwe vertaalvelden toegevoegd
-- Change date: 30/04/2010
-- Description: link met AnalysisMethodGroup tabel
-- =============================================
ALTER PROCEDURE [dbo].[AddAnalysisMethod] 
	@Group INT,
	@Name VARCHAR(50),
	@NameFR VARCHAR(50),
	@NameEN VARCHAR(50),
	@NameDE VARCHAR(50),
	@Version VARCHAR(50),
	@Active BIT
AS
BEGIN
	DECLARE @RetVal INT

	INSERT INTO AnalysisMethod(AnalysisMethodGroupID_FK, AnalysisMethodName,AnalysisMethodNameFR, AnalysisMethodNameDE, AnalysisMethodNameEN, AnalysisMethodScientificVersion, Active)
	VALUES(@Group, @Name,@NameFR, @NameDE, @NameEN, @Version,@Active)
	
	SELECT @RetVal = @@IDENTITY
	
	RETURN @RetVal
END

GO

